Validation Types
YoBulk does not put any restriction on the validation type.As a developer you can always define the field type
as string and add custom regex through pattern.
Please refer YoBulk Schema for the deatils.
For Nocode users like product managers and CS teams,YoBulik supports the following core validation types.
YoBulk offers the following field data types to parse and display it to the user and validate it.
| Field Type | Description |
|---|---|
| String | represents a string of characters. Can take numeric values also including Special characters.*Please add a Regex like (?!^d+$)^.+$ if you want to only accept characters. |
| Integer | Only takes numeric values. |
| Date | Parses Dates in several formats.Please check Date section for more details. |
| An email field is a string field with a built-in email address validation. | |
| Boolean | This checks a boolean (yes/no) field.Please check Boolean section for the details. |
String Field Type:
By default (if no field type is specified), all fields in YoBulk have the string type. It can take numeric values also including Special characters.Please add a Regex like (?!^d+$)^.+$ if you want to only accept characters.
Date Field Type:
YoBulk supports all the data formats defined underRFC3339
YoBulk validation engine can recognize the below date formats as valid date format. When a column field is marked as a date type,then YoBulk validation engines check the data against the following date format.It flags an error if it finds any data which does not match any of the below valid date formats.
Accepted Date format supported:
| Date Type | Example |
|---|---|
| DD/MM/YYYY | 27/03/1998 |
| DD/MM/YY | 27/03/98 |
| DD-MM-YYYY | 27-03-1998 |
| DD-MM-YY | 27-03-98 |
| DD.MM.YYYY | 27.03.1998 |
| DD.MM.YY | 27.03.98 |
| YYYY-MM-DD | 1998-03-27 |
| MM/DD/YYYY | 03/27/1998 |
| MM/DD/YY | 03/27/98 |
| MM-DD-YYYY | 03-27-1998 |
| MM-DD-YY | 03-27-98 |
| MM.DD.YYYY | 03.27.1998 |
Email Field Type:
YoBulk validation engine can recognize and valiate any email data type. An email field is a string field with a built-in email address validation. A validation error will be added to a cell if it contains an invalid email address.
Number Field Type::
If specified as numeric,YoBulk only validates the field as numeric value. A validation error will be added to a cell if it contains an integer.
- For any integer with special space and special character,it's suggested to use string as data type.
Boolean Field Type::
This is useful when you want to import a boolean (yes/no) field. YoBulk natively support the below boolean format types.
| Sl no | Supported formats |
|---|---|
| 1 | yes/no |
| 2 | 0/1 |
| 3 | true/false |
| 4 | TRUE/FALSE |
| 5 | Y/N |
| 6 | ON/OFF |
| 7 | UP/DOWN |